﻿CREATE TABLE [dbo].[Calendarizacion] (
    [IdCalendarizacion] INT           IDENTITY (1, 1) NOT NULL,
    [IdCuestionario]    INT           NOT NULL,
    [Fecha]             DATETIME      NOT NULL,
    [TiempoExamen]      INT           NOT NULL,
    [FechaCierre]       DATETIME      NOT NULL,
    [Intentos]          INT           NOT NULL,
    [Descripcion]       VARCHAR (300) NOT NULL,
    [Estado]            VARCHAR (20)  NOT NULL,
    CONSTRAINT [PK_Calendarizacion] PRIMARY KEY CLUSTERED ([IdCalendarizacion] ASC, [IdCuestionario] ASC)
);

